Use the Pivot Cross-Tab command to pivot a cross-tab on its axis, turning columns into rows and rows into columns. Use the Cross-Tab command on the Insert menu to create a cross-tab object.
Cross-Tab Objects